 

package openhome.bo;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import openHome.dao.MySQLConexionBD;
 
public class UsuariosBO {
     ResultSet rs;
    Connection cn;
    String sql="";
     
    public ResultSet traerUsuarios(){
        try {            
            cn = (Connection) MySQLConexionBD.getInstance().getConnection();
            Statement statement = cn.createStatement();
            sql="select idusuario,nombre,'#$%&/()=' as clave,tipo " ;
            sql+="from usuarios a left join usuario_tipo b on a.idtipo=b.idtipo ";
            
            rs= statement.executeQuery(sql);
             
        } catch (SQLException ex) {
            Logger.getLogger(DispositivosBO.class.getName()).log(Level.SEVERE, null, ex);
        }
        return rs;        
    }
}
